DROP TABLE erp_parameter_list

/****** Object:  Table [dbo].[erp_parameter_list]    Script Date: 06/24/2010 15:17:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[erp_parameter_list](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[report_id] [int] NOT NULL,
	[parameter] [varchar](45) NOT NULL,
	[object] [varchar](20) NOT NULL,
	[labeltext] [varchar](20) NOT NULL,
	[picker] [varchar](45) NOT NULL,
	[parameter_name] [varchar](45) NOT NULL,
	[field_name] [varchar](50) NOT NULL,
	[dynamic_name] [varchar](50) NOT NULL,
	[default_value] [varchar](200) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ((0)) FOR [report_id]
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [parameter]
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [object]
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [labeltext]
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [picker]
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [parameter_name] 
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [field_name]
GO
 
ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [dynamic_name]
GO

ALTER TABLE [dbo].[erp_parameter_list] ADD  DEFAULT ('') FOR [default_value]
GO